HomePage

Author

Sean Kim

PM566 Final Project Description

High quality outpatient preventative care, or Primary care, is a critical aspect of a successful healthcare system. Chronic conditions, minor incidents, and preventable acute conditions can all be managed by adequate primary care. When primary care is difficult to access, the mode of healthcare people often turn to is the emergency room and hospitals. When patients end up hospitalized for conditions that could have been prevented or managed with appropriate access to outpatient primary care, these hospitalizations are considered “preventable”. The California department of Health and Human Services (CalHHS) tracks both preventable hospitalizations and primary care provider shortage data. Two datasets were analyzed from the CalHHS website: Preventable Hospitalizations and Primary Care Provider Shortage in order to answer the question: is a shortage of primary care providers associated with increased rates of preventable hospitalization? The final report is available for download from this website (see navigation bar). Included in this homepage are plots used in the final report and brief descriptions.

Figure 1: Boxplots showing the distribution of preventable hospitalization rates adjusted for sex, age, and socioeconomic status and displayed in separate facets by diagnosis.
Figure 2: distribution of scores of providers by county. 0 is 0-1000 persons per provider; 1 is 1000-1500; 2 is 1500-2000; 3 is 2000-2500; 4 is 2500-3000; 5 is >3000.
Warning in RColorBrewer::brewer.pal(N, "Set2"): n too large, allowed maximum for palette Set2 is 8
Returning the palette you asked for with that many colors

Warning in RColorBrewer::brewer.pal(N, "Set2"): n too large, allowed maximum for palette Set2 is 8
Returning the palette you asked for with that many colors
Figure 3: Risk adjusted rate per 100k of overall preventable hospitalizations (adjusted for age, sex, and socioeconomic status by county), versus average county scores for provider shortage scores. Interactive plot, comparison available.
`geom_smooth()` using formula = 'y ~ x'
Figure 4: Plots of preventable hospitalization rates vs population:provider ratio separated by diagnosis.
`geom_smooth()` using formula = 'y ~ x'
Figure 5: Rate of preventable hospitalizatoin vs Provider shortage score based on composite measures. Diabetes composite is made up of short term complications, long term complications, lower extremity amputation due to diabetes, and uncontrolled diabetes. Chronic composite is made up of diabetes composite measures, COPD and Asthma in older and younger adults, hypertension, and heart failure admissions rates. Acute composite is made up of community acquired pneumonia and urinary tract infection admissions rates.